Overview: SQL Update

Use this operation to set field values by writing your own SQL update SET query. You can also define your own WHERE update query. The WHERE query will help you to specify the exact areas in your dataset on which to apply the SET query. This operation will modify your existing dataset by changing the selected field values to that specified in your SET query.

NOTE: CSense provides secure native blocks and operations for building analytics and solutions. The native capabilities provided by CSense can be extended by making use of this feature. When making use of this feature, please ensure that you have validated your extended functions to ensure that they perform as intended and do not introduce stability or security risks to your production system. Do not use scripts or components from untrusted sources.

Properties

Category:	Modify
Performance risk:	Low performance risk
Knowledge required:	Working knowledge of SQL

Effect on datasets

How many datasets are required to perform this operation?	One
Does it create a new dataset?	No
Can you reconfigure this operation?	Yes
Can you apply this operation to a locked dataset?	No
Does it modify the current dataset in any way?	Yes

Requirements

This operation needs a dataset that contains at least one field.

Results

A modified dataset with the field values set to the user defined value during the update query.